USE [Yacht Rental]
GO

/****** Object:  Table [dbo].[Boats]    Script Date: 10/17/2017 1:48:25 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Boats](
	[BoatID] [int] NOT NULL,
	[id_boat] [int] NULL,
	[CountryID] [int] NULL,
	[typeID] [int] NULL,
	[ModelID] [int] NULL,
	[ImageID] [int] NULL,
	[BaseID] [int] NULL,
	[DestinationAndBaseID] [int] NULL,
	[FleetoperaterID] [int] NULL,
	[name] [varchar](50) NULL,
	[widthboat] [float] NULL,
	[caution] [int] NULL,
	[cautionwithsI] [int] NULL,
	[builderyear] [date] NULL,
	[reffitedyear] [date] NULL,
	[crew_members] [int] NULL,
	[portregistration] [varchar](100) NULL,
	[registrationnum] [int] NULL,
	[boattaxoffice] [varchar](50) NULL,
	[boatlicence] [varchar](50) NULL,
	[grt] [int] NULL,
	[net] [int] NULL,
	[flag] [varchar](50) NULL,
	[insurance] [varchar](50) NULL,
	[class] [varchar](50) NULL,
	[bt_salon] [int] NULL,
	[bt_frontpeak] [int] NULL,
	[bt_dbberth] [int] NULL,
	[bt_comment] [varchar](max) NULL,
	[visible_cab] [int] NULL,
	[builder] [varchar](50) NULL,
	[std_model] [varchar](50) NULL,
	[comagt] [int] NULL,
	[crew_pax] [int] NULL,
	[chps1] [int] NULL,
 CONSTRAINT [PK_Boats] PRIMARY KEY CLUSTERED 
(
	[BoatID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


